2015-08-10 - 21048 - Break Fix - Restrict Open order data loads #SalesDistribution
Break Fix
21048 - Restrict Open order data loads
Problem Summary
Need to restrict the open orders & contract loads by using DTP routine filter for current year and previous year.
Admin Info
Purpose
|
Need to restrict the open orders & contract loads by using DTP routine filter for current year and previous year.
|
Requested by
|
Mark Harris
|
Issue Date
|
08-10-2015
|
Resolved by
|
Uday Kumar P
|
Resolved Date
|
08-12-2015
|
Document Status
|
Complete
|
Detailed Problem Description
The current data loads of open order & contract cubes are taking longer time to complete because of the huge volume of the records in the Sales order DSO. Due to this delay in the data loads, the reports are getting blank data and has to be rerun again causing the delay of the reports to the users.
Solution Analysis and Recommendations
As there will not be any open orders and contracts prior to previous year, it is not necessarily needed to evaluate the Sales orders for those years. Hence the filter for Current and previous year need to be applied.
Resolution
Need to apply the filter in open order cube & contract cube DTP's to load data previous year onwards for both Global & regional cubes.
Release Information
2015-08-10 - 21048 - Rel Notes - Restrict Open order data loads